<!DOCTYPE html>
<html lang="zh">
<head>
    <meta charset="UTF-8">
    <title>运动场馆预约</title>
    <style>
    * {
        box-sizing: border-box;
    }
        html , body {
          width: 100%;
          height: 100%;
          margin: 0;
          padding: 0;
        }
        body {
          padding: 10px;
        }
        .left {
            display: inline-block;
            width: 25%;
            height: 100%;
            overflow: auto;
            border-right: 1px solid #DFE3EB;
            padding: 10px
        }
        .right {
            display: inline-block;
            width: 75%;
            height: 100%;
            padding: 10px;
            overflow: auto;
        }
        .index {
            font-weight: bold;
            font-size: 25px;
        }
        li {
            list-style: none;
            padding: 5px;
        }
        .first-li {
            font-weight: bold;
            font-size: 20px;
        }
        .second-li {
            font-weight: bold;
        }
        .third-li {
            font-weight: normal;
        }
        .block {
            display: block;
        }
        table {
            width: 100%;
            margin-top: 10px;
            border-color: #E8E8E8;
        }
        .first-tr {
            text-align: center;
        }
        tr:hover {
            background: #ECF9FF;
        }
        td {
            font-weight: normal;
            padding: 5px;
            white-space: nowrap;
        }
        a {
            color: #000000;
            background-color: transparent;
            text-decoration: none;
            outline: none;
            cursor: pointer;
        }
        .group {
            color: green;
        }
        .group-list {
            color: #1890ff;
        }
    </style>
</head>
<body><span class="left"><center class="index">目录</center>
<hr><ul>
<li class="first-li"><a class="group" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-from" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-to">1 用户端</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-diagrams-from" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-from" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-from" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-views-from" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-views-column-from" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-dicts-from" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-dicts-column-from" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-__defaultGroup-from" href="#group-__defaultGroup-to">2 默认主题域</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-diagrams-from" href="#group-__defaultGroup-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-entities-from" href="#group-__defaultGroup-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-__defaultGroup-entities-column-from" href="#group-__defaultGroup-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-views-from" href="#group-__defaultGroup-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-__defaultGroup-views-column-from" href="#group-__defaultGroup-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-dicts-from" href="#group-__defaultGroup-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-__defaultGroup-dicts-column-from" href="#group-__defaultGroup-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul></ul>
</span><span  class="right"><ul>

<li class="first-li"><a class="group" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-from">1 用户端</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-diagrams-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-diagrams-from">1.1 关联关系清单</a>
<img style="width: 98%;margin-top: 10px" src="" title="用户端-关系图-1"/>
</li><hr>
<li><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-from">1.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>用户信息表</td><td>sys_user</td><td></td></tr>
<tr><td>预约明细</td><td>now_order</td><td></td></tr>
<tr><td>场馆基础信息</td><td>venues_base</td><td></td></tr>
<tr><td>场馆日时间段</td><td>venues_date_day</td><td></td></tr>
<tr><td>场地类型</td><td>venues_type</td><td></td></tr>
<tr><td>场馆明细</td><td>venues_detail</td><td></td></tr>
<tr><td>场馆周时间段</td><td>venues_date_week</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-from">1.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-CD31A573-0C5F-4DD2-ACA2-053D81737794-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-CD31A573-0C5F-4DD2-ACA2-053D81737794-from">1.2.2.1 sys_user[用户信息表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>长度</td><td>主键</td><td>默认值</td><td>备注</td></tr>
<tr><td>user_id</td><td>用户ID</td><td>VARCHAR</td><td>255</td><td>√<td></td></td><td></td></tr>
<tr><td>user_name</td><td>用户名</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>user_pwd</td><td>用户密码</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>user_create_time</td><td>创建日期</td><td>DATETIME</td><td></td><td><td></td></td><td></td></tr>
<tr><td>user_avatar</td><td>用户头像</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>user_phone</td><td>用户手机号</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>user_address</td><td>用户住址</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-8348F1D0-0A30-4569-A12C-B7D7399A4880-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-8348F1D0-0A30-4569-A12C-B7D7399A4880-from">1.2.2.2 now_order[预约明细]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>长度</td><td>主键</td><td>默认值</td><td>备注</td></tr>
<tr><td>user_id</td><td>用户ID</td><td>VARCHAR</td><td>255</td><td>√<td></td></td><td></td></tr>
<tr><td>user_name</td><td>用户名</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>order_datetime</td><td>预约时间</td><td>DATETIME</td><td></td><td><td></td></td><td></td></tr>
<tr><td>venues_id</td><td>预约场馆ID</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>venues_number</td><td>预约馆号</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>order_week</td><td>周时间段</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>order_day</td><td>日时间段</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>order_status</td><td>预约状态</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>order_start</td><td>预约开始时间</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>order_end</td><td>预约结束时间</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-9A459ECF-2E30-4934-A714-4ADA9CB417AB-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-9A459ECF-2E30-4934-A714-4ADA9CB417AB-from">1.2.2.3 venues_base[场馆基础信息]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>长度</td><td>主键</td><td>默认值</td><td>备注</td></tr>
<tr><td>venues_id</td><td>场馆ID</td><td>VARCHAR</td><td>255</td><td>√<td></td></td><td></td></tr>
<tr><td>venues_name</td><td>场馆名称</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>venues_address</td><td>场馆地址</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>venues_admin</td><td>场馆负责人</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>venues_admin_phone</td><td>场馆负责人电话</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>venues_avatar</td><td>场馆头像</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-E43113E9-19E9-446F-B5D5-56CA3B5E9305-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-E43113E9-19E9-446F-B5D5-56CA3B5E9305-from">1.2.2.4 venues_date_day[场馆日时间段]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>长度</td><td>主键</td><td>默认值</td><td>备注</td></tr>
<tr><td>venues_id</td><td>场馆ID</td><td>VARCHAR</td><td>255</td><td>√<td></td></td><td></td></tr>
<tr><td>venues_number</td><td>馆号</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_8_9</td><td>8:00~9:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_9_10</td><td>9:00~10:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_10_11</td><td>10:00~11:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_11_12</td><td>11:00~12:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_14_15</td><td>14:00~15:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_15_16</td><td>15:00~16:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_16_17</td><td>16:00~17:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_17_18</td><td>17:00~18:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_18_19</td><td>18:00~19:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_19_20</td><td>19:00~20:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_20_21</td><td>20:00~21:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>day_21_22</td><td>21:00~22:00</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-A498619F-1053-427D-9244-8F8F3862974B-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-A498619F-1053-427D-9244-8F8F3862974B-from">1.2.2.5 venues_type[场地类型]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>长度</td><td>主键</td><td>默认值</td><td>备注</td></tr>
<tr><td>venues_id</td><td>场馆ID</td><td>VARCHAR</td><td>255</td><td>√<td></td></td><td></td></tr>
<tr><td>venues_number</td><td>馆号</td><td>INT</td><td></td><td>√<td></td></td><td></td></tr>
<tr><td>type</td><td>1-羽毛球，2-篮球，3-乒乓球，4-机械，5-排球</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-64689C14-C3ED-4FC7-BA77-C901EB50448A-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-64689C14-C3ED-4FC7-BA77-C901EB50448A-from">1.2.2.6 venues_detail[场馆明细]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>长度</td><td>主键</td><td>默认值</td><td>备注</td></tr>
<tr><td>venues_id</td><td>场馆ID</td><td>VARCHAR</td><td>255</td><td>√<td></td></td><td></td></tr>
<tr><td>venues_number</td><td>馆号</td><td>INT</td><td></td><td>√<td></td></td><td></td></tr>
<tr><td>venues_image</td><td>馆内照片</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
<tr><td>venues_room</td><td>馆内房间总数</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>venues_room_current</td><td>馆内当前剩余房间数</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>venues_room_use</td><td>馆内房间使用数</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>venues_room_address</td><td>馆内房间地址</td><td>VARCHAR</td><td>255</td><td><td></td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-876DB02A-3651-4869-94CE-1E1D7313F4F6-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-entities-column-876DB02A-3651-4869-94CE-1E1D7313F4F6-from">1.2.2.7 venues_date_week[场馆周时间段]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>长度</td><td>主键</td><td>默认值</td><td>备注</td></tr>
<tr><td>venues_id</td><td>场馆ID</td><td>VARCHAR</td><td>255</td><td>√<td></td></td><td></td></tr>
<tr><td>venues_number</td><td>馆号</td><td>INT</td><td></td><td>√<td></td></td><td></td></tr>
<tr><td>week_1</td><td>周一，0-无，1-本周，2-下周</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>week_2</td><td>周二，0-无，1-本周，2-下周</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>week_3</td><td>周三，0-无，1-本周，2-下周</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>week_4</td><td>周四，0-无，1-本周，2-下周</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>week_5</td><td>周五，0-无，1-本周，2-下周</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>week_6</td><td>周六，0-无，1-本周，2-下周</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>week_7</td><td>周日，0-无，1-本周，2-下周</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-views-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-views-from">1.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-views-column-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-views-column-from">1.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-dicts-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-dicts-from">1.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-dicts-column-to" href="#group-2DE6DC18-68CB-49DC-9040-F38187C72AEF-dicts-column-from">1.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-__defaultGroup-to" href="#group-__defaultGroup-from">2 默认主题域</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-__defaultGroup-diagrams-to" href="#group-__defaultGroup-diagrams-from">2.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-__defaultGroup-entities-to" href="#group-__defaultGroup-entities-from">2.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>TABLE_1</td><td>TABLE_1</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-__defaultGroup-entities-column-to" href="#group-__defaultGroup-entities-column-from">2.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-__defaultGroup-entities-column-D31E703C-9CCB-4258-BD9F-45486CF36A95-to" href="#group-__defaultGroup-entities-column-D31E703C-9CCB-4258-BD9F-45486CF36A95-from">2.2.2.1 TABLE_1[]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型(MYSQL)</td><td>长度</td><td>主键</td><td>默认值</td><td>备注</td></tr>
<tr><td>TENANT_ID</td><td>租户号</td><td>VARCHAR</td><td>32</td><td><td></td></td><td></td></tr>
<tr><td>REVISION</td><td>乐观锁</td><td>INT</td><td></td><td><td></td></td><td></td></tr>
<tr><td>CREATED_BY</td><td>创建人</td><td>VARCHAR</td><td>32</td><td><td></td></td><td></td></tr>
<tr><td>CREATED_TIME</td><td>创建时间</td><td>DATETIME</td><td></td><td><td></td></td><td></td></tr>
<tr><td>UPDATED_BY</td><td>更新人</td><td>VARCHAR</td><td>32</td><td><td></td></td><td></td></tr>
<tr><td>UPDATED_TIME</td><td>更新时间</td><td>DATETIME</td><td></td><td><td></td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-__defaultGroup-views-to" href="#group-__defaultGroup-views-from">2.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-__defaultGroup-views-column-to" href="#group-__defaultGroup-views-column-from">2.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-__defaultGroup-dicts-to" href="#group-__defaultGroup-dicts-from">2.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-__defaultGroup-dicts-column-to" href="#group-__defaultGroup-dicts-column-from">2.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li></ul></span></body>
</html>